﻿<%@ Page Title="Flt. Duplicate Orders" Language="C#" Culture="auto" UICulture="auto" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="FltDupBookings.aspx.cs" Inherits="IFD2.FltDupBookings" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
    <form id="form1" runat="server" role="form" class="form-inline" defaultbutton="lbtnQuery">
    <div class="container-fluid body-content" style="width:100%;">

        <div class="row">
        <div class="col-sm-2 well well-sm">
            <h5><asp:Literal ID="litTitle" runat="server" meta:resourcekey="tipPageTitle"></asp:Literal></h5>
            <div class="form-group">
                <asp:Label ID="Label1" runat="server" Text="Flight:" meta:resourcekey="Flight"></asp:Label>
                <asp:Label ID="lblAirline" runat="server"></asp:Label>
                <asp:TextBox ID="txtFltNo" runat="server" CssClass="form-control input-sm" Width="100%" MaxLength=4></asp:TextBox>
                <asp:Label ID="Label2" runat="server" Text="Date:" meta:resourcekey="Date"></asp:Label>
                <asp:TextBox ID="txtFltDate" runat="server" CssClass="form-control input-sm" Width="100%" MaxLength=15></asp:TextBox>
            </div>
            <br class="hidden-xs"/><br class="hidden-xs"/>
            <asp:LinkButton ID="lbtnQuery" runat="server" CssClass="form-control input-sm btn-primary text-center" Width="100%" ToolTip="" meta:resourcekey="tipQuery" OnClick="lbtnQuery_Click"> <span class="glyphicon glyphicon-search" style="font-size:large;"></span></asp:LinkButton>
            <p></p><%--没有此行(或&nbsp;)，上面的按钮在手机模式(xs)下，只有上半部可以点击！--%>
            <asp:Label ID="lblError" runat="server" CssClass="ifdMessage"></asp:Label>
        </div>

        <div class="col-sm-10 well well-sm">
            <div class="panel">
                <div class="panel-heading btn-primary">
                    <h6 class="panel-title" id="section-2"><asp:Literal ID="Literal1" runat="server" meta:resourcekey="tipPageTitle"></asp:Literal></h6>
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
                        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" class="table-hover" style="min-width:2000px;width:100%;" 
                            CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None">
                            <AlternatingRowStyle BackColor="White" />
                            <Columns>
                                <asp:TemplateField HeaderText="bk_id" SortExpression="bk_id" meta:resourcekey="bk_id">
                                    <ItemTemplate>
                                        <asp:LinkButton runat="server" PostBackUrl='<%# "Order.aspx?pnr="+Eval("bk_id") %>'><%#Eval("bk_id") %></asp:LinkButton>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField DataField="pax_sn" HeaderText="pax_sn" 
                                    SortExpression="pax_sn"  meta:resourcekey="pax_sn" />
                                <asp:BoundField DataField="status" HeaderText="status" 
                                    SortExpression="status"  meta:resourcekey="status" />
                                <asp:TemplateField HeaderText="name" SortExpression="name" meta:resourcekey="name">
                                    <ItemTemplate>
                                        <%#Eval("family_name") +"/"+ Eval("name")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="name_en" SortExpression="name_en" meta:resourcekey="name_en">
                                    <ItemTemplate>
                                        <%#Eval("family_name_en") +"/"+ Eval("name_en")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField DataField="id_no" HeaderText="id_no" SortExpression="id_no"  meta:resourcekey="id_no" />
                                <asp:TemplateField>
                                    <ItemTemplate>
                                        |
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField DataField="airline" HeaderText="airline" 
                                    SortExpression="airline"  meta:resourcekey="airline" />
                                <asp:BoundField DataField="op_airline" HeaderText="op_airline" 
                                    SortExpression="op_airline"  meta:resourcekey="op_airline" />
                                <asp:BoundField DataField="flt_no" HeaderText="flt_no" 
                                    SortExpression="flt_no"  meta:resourcekey="flt_no" />
                                <asp:BoundField DataField="flt_date" HeaderText="flt_date" 
                                    SortExpression="flt_date"  meta:resourcekey="flt_date" />
                                <asp:TemplateField HeaderText="dup_bk_id" SortExpression="dup_bk_id" meta:resourcekey="dup_bk_id">
                                    <ItemTemplate>
                                        <asp:LinkButton runat="server" PostBackUrl='<%# "order_details2.aspx?pnr="+Eval("dup_bk_id") %>'><%#Eval("dup_bk_id")%></asp:LinkButton>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField DataField="dup_pax_sn" HeaderText="dup_pax_sn" 
                                    SortExpression="dup_pax_sn"  meta:resourcekey="dup_pax_sn" />
                                <asp:BoundField DataField="dup_status" HeaderText="dup_status" 
                                    SortExpression="dup_status"  meta:resourcekey="dup_status" />
                                <asp:TemplateField HeaderText="dup_name" SortExpression="dup_name" meta:resourcekey="dup_name">
                                    <ItemTemplate>
                                        <%#Eval("dup_family_name") + "/" + Eval("dup_name")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="dup_name_en" SortExpression="dup_name_en" meta:resourcekey="dup_name_en">
                                    <ItemTemplate>
                                        <%#Eval("dup_family_name_en") + "/" + Eval("dup_name_en")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                            <EditRowStyle BackColor="#2461BF" />
                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                            <RowStyle BackColor="#EFF3FB" />
                            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                            <SortedAscendingCellStyle BackColor="#F5F7FB" />
                            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                            <SortedDescendingCellStyle BackColor="#E9EBEF" />
                            <SortedDescendingHeaderStyle BackColor="#4870BE" />
                        </asp:GridView>
                    </div>

                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>" 
                        SelectCommand="bll_flt_get_duplicate_orders" SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <asp:SessionParameter DefaultValue="" Name="airline" SessionField="AIRLINE" Type="String" />
                            <asp:ControlParameter ControlID="txtFltNo" Name="flt_no" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtFltDate" Name="flt_date" PropertyName="Text" Type="DateTime" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </div>

            </div>
        </div>
    </div>

    </div></form>
</asp:Content>
